SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:If you’re looking for a full-time residence or a second home where everyone can gather, spread out, and truly reconnect, 3 Fairway Drive in the Eastman Community delivers. This 5-bedroom, 5-bath contemporary Cape offers a smart, flexible floor plan designed for long weekends, holidays, and memorable summer stays with family and friends. Two en suite bedrooms on the main level make hosting effortless and ideal for single-level living, while the upper-level bedrooms provide cozy, private retreats for guests, or extended family. At the heart of the home, the centrally located kitchen keeps everyone connected, flowing seamlessly into the dining room, family room, and living room—perfect for shared meals, games, and relaxed evenings together. Outdoor living shines here. The screened porch and expansive deck invite morning coffee with golf-course views, afternoon grilling, evening stargazing, and casual gatherings that stretch late into the night. The finished walk-out lower level adds even more versatility, featuring a bedroom, office, family room, and generous storage for skis, beach gear, and all the essentials of active New England living. Set on a private 0.62-acre lot with an attached two-car garage, this home offers full access to Eastman’s lake, beaches, trails, golf course, and recreation center—within a welcoming, amenity-rich community built for year-round enjoyment. Conveniently located just minutes from Dartmouth Hitchcock Medical Center and Dartmouth College, this is a place where lifestyle, comfort, and connection come together.
Description:Superb location just minutes from Main Street, Hanover and Dartmouth College on desirable Haskins Rd, a quiet dead end street. This 3 bedroom, 2 bath home features a family room with fireplace, dining area and updated kitchen on the main floor with hardwood floors throughout. Upstairs the primary bedroom is situated at the rear of the home with a loft for storage, 2 additional bedrooms, a full bath and a sunny office. Bring your ideas and refresh this cozy contemporary to make it your own while enjoying the peaceful, wooded surroundings. Hiking trails, including the AT, are close by. Conveniently located close to town, schools and short 10 min commute to Dartmouth Health. Showings will begin on Friday BY APPOINTMENT between 3-5 and Saturday BY APPOINTMENT from 11-1.
Description:PRICE IMPROVEMENT: Spacious home located in the Olde Farms community (not an HOA) and an Approx. 25-minute drive to DHMC. The home is nestled on 7.92 private acres located in beautiful Grantham NH. This spacious 4-bedroom, 3.5-bath home offers the perfect blend of privacy, comfort, and convenience. Set well back from the main road, the property provides a peaceful country setting with stunning views and plenty of room to enjoy the outdoors. Inside, you’ll find generous living space throughout, including two oversized unfinished bonus rooms ready for your personal touch — ideal for a home office, gym, guest suite, media room, or additional living space. The large basement offers even more storage or expansion potential. Step outside to relax on the expansive deck or unwind in the hot tub while taking in the scenic surroundings. Additional highlights include a two-car garage, paved driveway, and an on-demand generator for added peace of mind. Despite its tranquil setting, this property offers easy access to Interstate 89, making commuting and travel convenient while still enjoying the beauty and privacy of country living. Approximately 25-minute drive to DHMC and other Upper valley amenities. A rare opportunity to own a private country property in one of Grantham’s most desirable locations.
Description:What a gem situated within the big little city of Lebanon, NH. Built during the Eastlake Architectural movement in 1860 this Victorian home has all the features one expects to see for the time period including ornate floral carvings that adorn the exterior. Tastefully updated by the few owners who have appreciated her history, this home provides ample space for cohabitation of one or more generations of occupants. Off the rear of the home, where you will find ample parking, is a separate entrance that could be used as a home based office complete with kitchenette and bathroom. It can even serve as quarters for an in home assistant to the residents or good friend or family member. From the front or side covered porch you enter the main home and appreciate the history that flows from its rooms. Two options for a first floor bedroom are available for those who desire or need single level living. A three season sunroom on the second floor could function as a game room, exercise space or a space to entertain or hang 10; the possibilities abound. Combine this with ample sized sleeping rooms including an impressive primary suite, the second floor fosters a feeling of home with its comfort and warmth. The basement would make for an impressive home based gym essential for the winter months when we feel somewhat trapped by the weather or perhaps even a daycare as I understand it once was. Walking distance to the Marsh Brothers Deli, Lucky's Coffee House, Village Pizzeria, Salthill Irish pub, Three Tomatoes Italian Restaurant and Lebanon Opera House means the property is near the Lebanon Green famous for its outdoor concerts, farmers markets and festivals. Perhaps you're interested in an investment property vs. a single family dwelling? This home and layout provides many opportunities.
Description:A sportsman's Paradise! Set on 5.5 private acres in a quiet rural setting, this well-built 2008 log home offers the warmth and character so many buyers are looking for. With 3 bedrooms and soaring cathedral ceilings, cherry and red oak hardwood flooring, the home feels open, comfortable, and connected to its natural surroundings. Recent improvements include a new heating system, adding efficiency and peace of mind. A large wraparound deck creates great outdoor living space for relaxing, entertaining, or taking in the peaceful setting. The property abuts conservation land with established trails, giving you direct access to hiking, snowshoeing, and year-round outdoor recreation right from the backyard. The location offers a nice balance of privacy and convenience, with close proximity to Mascoma Lake, Mt Sunapee, Whaleback, DH Medical Center and all Upper Valley amenities. Whether you're looking for a year-round home or a getaway in New Hampshire, this property captures the classic feel of log home living in a beautiful Enfield setting.
Description:Nestled along the waterfront of Anderson Pond within the sought-after Eastman Community, this fully renovated home offers an exceptional blend of modern comfort and four-season recreation. Thoughtfully updated throughout, the home features all new windows and doors, spray foam insulation for outstanding efficiency, a heated bonus room over the garage, a standing seam metal roof and a beautifully redesigned kitchen with new appliances and striking Dekton countertops. The focal point beyond the water view is the stone fireplace. As for the community, enjoy the unmatched lifestyle of Eastman’s 3,700-acre residential community surrounding a 345-acre lake, featuring six beaches, championship golf, tennis and pickleball courts, a fitness center, indoor pool, and miles of walking and hiking trails. Whether spending summer days on the water, golfing a scenic round, or enjoying year-round recreation, this property offers waterfront living paired with resort-style amenities in one of New Hampshire’s premier four-season communities.
Description:Fabulous location in highly desirable Hanover, NH! This charming Cape offers the perfect blend of character, comfort, and convenience, just minutes to downtown Main Street, the Co-op, Hanover Elementary, Middle, and High School, Dartmouth College, and with easy access to Dartmouth-Hitchcock Medical Center. Featuring 4 bedrooms, a flexible bonus room, and 3 bathrooms, highlighted by a generous primary suite with dual closets and a private 3/4 bath, this warm and inviting home is filled with classic charm. Cozy up by the wood-burning fireplace with an insert or enjoy relaxing summer evenings on the screened porch overlooking a beautiful yard, perfect for playing or entertaining. Beautiful wood floors flow throughout the main living areas, adding warmth and timeless appeal. The first floor offers a functional layout with an eat-in kitchen, pantry, and mudroom area, along with a comfortable family room and a dining space with a wood-burning stove. A bonus room provides flexibility for a home office or spare bedroom, along with a full bathroom on the main level. Upstairs, you’ll find four bedrooms, including a primary suite with its own private 3/4 bath, along with an additional 3/4 bath. Additional features include a partially finished basement, ideal for a quiet workspace, workout area, or extra storage; and easy access to everything Hanover has to offer. Located in a top-rated school district, with school bus pickup steps away, this home offers both convenience and community. A truly sweet Cape in an unbeatable location; walkable, welcoming, and ready to call home. Don’t miss out! Showings begin at the open houses on Saturday, May 9th from 11:30 AM–1:00 PM and Sunday from 11:30 AM–1:00 PM. Experience the perfect blend of timeless charm and modern comfort, your Hanover home awaits.
Description:This 3 bedroom 2.5 bath home with attached 2 car garage is situated very privately on a beautifully landscaped 3.86 acres in the desirable community of Eastman! The interior is light and bright with many windows throughout. The very spacious primary suite has custom built-ins and an attached laundry room. With a generous den/office, working from home is a fabulous option and the two decks and a sunroom make for lovely areas to enjoy the outdoors and wildlife during your breaks. Two more bedrooms and a full bath up with tons of storage overlooking the living room below, and an additional sitting room in the loft for reading and watching the birds out the windows. Passive Solar and energy efficient! The additional 3 car garage with workshop and massive storage overhead is awaiting your antique cars. This one is calling your name!
Description:The sun streams in to this delightfully bright home set on a gorgeous 3.45 ac site in Lebanon. Spacious great room with beautiful outlook. 2648 sq ft home is currently set up as 1 bedroom, 2.5 bath, with large first floor master suite. Upstairs has a large family/game room and a full bath. Seller will give credit of builder's estimate to add two more bedrooms to the second floor. (House has a 4 bedroom septic system). Full basement provides great space for workshop or more finished space. 2 car garage. Open house Sunday, May 31 from 1--3pm.
Description:Spacious, move-in-ready, contemporary home with 3 bedrooms plus a bonus room, 4.5 baths and over 3,000 SF. Ideally situated on 2+ acres with privacy and views of the meadow and pond. Property abuts Grantham Recreational Park and conservation land. You’ll absolutely love the state-of-the-art kitchen featuring granite countertops, a large island, walk-in pantry, professional-grade gas range, custom tile backsplash, and two dishwashers. The open layout flows into a dining area and continues to an expansive living room with vaulted ceilings and a beautiful fireplace as the focal point. The first-floor primary suite offers a generous walk-in closet and two separate baths for convenience. Two more bedrooms, each with its own bath, and a bonus room are on the lower level. You'll also find a family room filled with natural light in the walkout lower level. Additional highlights include a home office, whole-house generator, direct entry from the 2-car garage, a screened porch, and large wraparound deck. Located just minutes from I-89, this property provides easy access to the Upper Valley and Dartmouth-Lake Sunapee Region. The area offers year-round opportunities for outdoor recreation including kayaking, fishing, skiing, ice skating, and more. All this in a lovely country setting.